/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package sv.com.intesal.reporte.sql;

/**
 *
 * @author jm
 */
public class SQLTipoReporte {

    public static final String insert="INSERT INTO TIPO_REPORTE(nombre_tr,extension_tr,contexttype_tr,headername_tr,headervalue_tr,estado_tr)VALUES(?,?,?,?,?,?)";
    public static final String update="UPDATE TIPO_REPORTE SET nombre_tr=?,extension_tr=?,contexttype_tr=?,headername_tr=?,headervalue_tr=?,estado_tr=? where codigo_tr=?";
    public static final String getTipoReporte_Activos="SELECT * FROM TIPO_REPORTE where estado_tr='A' ";
    public static final String getTipoReporte="SELECT * FROM TIPO_REPORTE where extension_tr=? and estado_tr='A' ";
    public static final String getAllTipoReportes="SELECT * FROM TIPO_REPORTE order by nombre_tr";
}